package com.yang.sms.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.yang.sms.entity.SmsTemplate;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
* @author Billyang
* @description 针对表【sms_template(短信模板)】的数据库操作Mapper
* @createDate 2024-09-26 17:56:28
*/
public interface SmsTemplateMapper extends BaseMapper<SmsTemplate> {
    @Select("select * from sms_template where channel = #{channel} and template_code = #{templateCode}")
    SmsTemplate selectByChannelTemplateCode(@Param("channel") String channel,
                                            @Param("templateCode") String templateCode);
}




